package com.ruoyi.conference.mapper;

import com.ruoyi.conference.domain.ConferenceAccountInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface HuaweiConferenceMapper {

    @Select("SELECT\n" +
            "\thca.userid userid,\n" +
            "\thca.conference_username conferenceUsername,\n" +
            "\thca.conference_password conferencePassword\n" +
            "FROM\n" +
            "\tsys_user su\n" +
            "JOIN `huawei_conference_account` hca ON su.user_id = hca.userid\n" +
            "WHERE\n" +
            "\tuserid = #{userid}")
    public ConferenceAccountInfo selectConferenceAccountInfo(Long userid);
}
